package com.bit.book.map;

import com.bit.book.model.BookInfo;
import com.bit.book.model.PageRequest;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface BookInfoMapper {


    @Insert("insert into book_info(book_name,author,count,price,publish,status)"
            +" values(#{bookName},#{author},#{count},#{price},#{publish},#{status})")
    void insertBook(BookInfo bookInfo);
    @Select("select count(1) from book_info where status!=0")
    Integer count();
    @Select("select * from book_info where status!=0 order By id asc limit #{offset},#{pageSize}")
    List<BookInfo> queryBookListByPage(PageRequest pageRequest);

    @Select("select id,book_name,author,count,price,publish,status,create_time,update_time"+
    " from book_info where id=#{id} and status!=0")
    BookInfo queryBookListById(Integer id);

    void updateBook(BookInfo bookInfo);

    void batchDeleteBook(List<Integer> ids);
}
